package com.laxcen.smoke.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface ScheduleDao {

    //获取设备编号轮询
    @Select("select distinct sm.no smartno from smart sm right join real_smart_smartboard rss on sm.id = rss.SmartId ")
    List<String> getSmartNo();

    @Select("select password from smart where password is not null and no = #{smartno}")
    String getpasswordSchedule(String smartno);

}
